home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Belgian Amiga Club - ADF Collection
/
BS1 part 23.zip
/
BS1 part 23
/
PD 163.adf
/
Bankn
/
expsum1.qry
< prev
next >
Wrap
Text File
|
1988-11-22
|
822b
|
43 lines
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| This is an example of a query with two levels
| of totals. Transactions are listed and totaled
| by Payee within Expense Code.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
select
(type = "C" or "W" or "S") and
(date > "123187" and date < "083188")
sort
ec, payee
report
top(ec)
ec
detail
col 6 payee
col 29 total(amount) "%99,999.99"
bottom(payee)
col 29 "---------"
skip
col 15 "Payee Total:"
col 38 total(amount) "%99,999.99"
bottom(ec)
col 38 "---------"
skip
col 18 "EC total:"
col 47 total(amount) "%99,999.99"
skip 2
report_bottom
col 47 "---------"
skip
col 13 "Overall Total:"
col 47 total(amount) "%99,999.99"